package com.atguigu.srb.core.mapper;

import com.atguigu.srb.core.pojo.entity.CommunityMemberInformation;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface CommunityMemberInformationMapper extends BaseMapper<CommunityMemberInformation> {


    @Select("SELECT * FROM community_member_information WHERE community_number = #{id} ANd is_deleted = 0")
    List<CommunityMemberInformation> selectByCommunityNumber(@Param("id") String  communitynumber);
}
